OpenEdge Data Management:<br />Database Administration PROUTIL TRUNCATE AREA qualifier

Specifies the database that contains the application data storage areas that you want to truncate.

Specifies the name of the storage area you want to truncate. When you specify the area name, PROUTIL truncates the area even if it contains storage objects. If no area name is specified, PROUTIL truncates all areas not containing objects.

Notes

proutil `db-name` -C truncate area `area-name`

Use of this qualifier is an important step in removing application data storage areas and extents from a database.

Deleting the contents of storage areas with this feature also allows for rapid dumping and loading. Use PROUTIL with the TRUNCATE AREA qualifier after dumping data, but before initiating the load.

PROUTIL with the TRUNCATE AREA qualifier works by resetting the hi-water mark in the storage area back to the beginning of the storage area. This hi-water mark reset frees all of the space in the storage area for reuse. Any tables and indexes in the storage areas are initialized to the state they were in before they contained any rows or index entries. Before resetting the hi-water mark, the before image (BI) file is truncated.

To use this command, the database must be off-line and after imaging must be disabled.

If the storage area does not contain any storage objects, then the command simply resets the hi-water mark. If the storage area does contain tables and or indexes, their names are listed and you must confirm to truncate the storage area.

Indexes in other storage areas that are on tables in the storage area being truncated are marked as inactive.

Empty index root blocks for indexes in the area being truncated are re-created.

PROUTIL with the TRUNCATE AREA qualifier re-creates any template records in the new area.

For an example of PROUTIL with the TRUNCATE AREA qualifier, see Chapter 14, " Maintaining Database Structure.".

PROUTIL TRUNCATE AREA qualifier

Syntax

Parameters

Notes